2015-08-06 - 20867 - Break Fix - Negative values in Contracts #SalesDistribution
Service Request
20867 - Negative values in Contracts
Problem Summary
Need to check why negative values are showing when the same Item, material, size combination has two different schedule line dates.
Admin Info
Purpose
|
Need to check why negative values are showing when the same Item, material, size combination has two different schedule line dates.
|
Requested by
|
Nicole Rybarczyk
|
Issue Date
|
08-12-2016
|
Resolved by
|
Naveen G
|
Resolved Date
|
Did not implement the changes.
|
Document Status
|
Complete
|
Detailed Problem Description
Email from Greg Jackson on 08-04-2015:
There are some negative values being displayed on OSA180. This is due to the fact of one material/size having multiple schedule delivery dates on the contract. When the call offs to these lines are created, the lookup logic that we have implemented doesn't distinguish between either date and I'm not sure how we would force one date or the other. Here are a few examples:
40012039 -260
40012040 -78
40012025 -50
Solution Analysis and Recommendations
Since there are multiple lines in the contract for the same grid size with different schedule line delivery dates, while doing the call off lookup in BW, the schedule line delivery date for the first line is updated for all the call offs created against the contract, resulting in negative values.
Resolution
Contract orders with negative orders are not appearing on the OSA180 report, as they got closed in ECC & not updated to contract order cube.
Need to implement the change for lookup logic to handle this scenario, if contract orders with negative values appear again in the OSA180.
Release Information
None